Dataset statistics
| Number of variables | 28 |
|---|---|
| Number of observations | 141497 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 10216 |
| Duplicate rows (%) | 7.2% |
| Total size in memory | 30.2 MiB |
| Average record size in memory | 224.0 B |
Variable types
| Categorical | 16 |
|---|---|
| Numeric | 12 |
| Dataset has 10216 (7.2%) duplicate rows | Duplicates |
country has a high cardinality: 177 distinct values | High cardinality |
agent has a high cardinality: 334 distinct values | High cardinality |
arrival_date_week_number is highly overall correlated with arrival_date_month | High correlation |
is_canceled is highly overall correlated with reservation_status | High correlation |
arrival_date_month is highly overall correlated with arrival_date_week_number | High correlation |
market_segment is highly overall correlated with distribution_channel | High correlation |
distribution_channel is highly overall correlated with market_segment | High correlation |
reservation_status is highly overall correlated with is_canceled | High correlation |
children is highly imbalanced (82.0%) | Imbalance |
babies is highly imbalanced (97.1%) | Imbalance |
country is highly imbalanced (55.1%) | Imbalance |
distribution_channel is highly imbalanced (57.0%) | Imbalance |
is_repeated_guest is highly imbalanced (80.1%) | Imbalance |
deposit_type is highly imbalanced (64.0%) | Imbalance |
required_car_parking_spaces is highly imbalanced (85.5%) | Imbalance |
adults is highly skewed (γ1 = 25.31842147) | Skewed |
previous_cancellations is highly skewed (γ1 = 20.19910718) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 25.27012254) | Skewed |
lead_time has 7756 (5.5%) zeros | Zeros |
stays_in_weekend_nights has 61849 (43.7%) zeros | Zeros |
stays_in_week_nights has 8790 (6.2%) zeros | Zeros |
previous_cancellations has 130585 (92.3%) zeros | Zeros |
previous_bookings_not_canceled has 137569 (97.2%) zeros | Zeros |
booking_changes has 120590 (85.2%) zeros | Zeros |
days_in_waiting_list has 137057 (96.9%) zeros | Zeros |
adr has 2369 (1.7%) zeros | Zeros |
total_of_special_requests has 85808 (60.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-09 16:51:57.653062 |
|---|---|
| Analysis finished | 2023-04-09 16:53:44.496900 |
| Duration | 1 minute and 46.84 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.690107 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1512618 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 92673 | |
| Resort Hotel | 48824 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| hotel | 141497 | |
| city | 92673 | |
| resort | 48824 | 17.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 282994 | |
| o | 190321 | |
| e | 190321 | |
| 141497 | ||
| H | 141497 | |
| l | 141497 | |
| C | 92673 | 6.1% |
| i | 92673 | 6.1% |
| y | 92673 | 6.1% |
| R | 48824 | 3.2% |
| Other values (2) | 97648 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1088127 | |
| Uppercase Letter | 282994 | 18.7% |
| Space Separator | 141497 | 9.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 282994 | |
| o | 190321 | |
| e | 190321 | |
| l | 141497 | |
| i | 92673 | 8.5% |
| y | 92673 | 8.5% |
| s | 48824 | 4.5% |
| r | 48824 | 4.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 141497 | |
| C | 92673 | |
| R | 48824 | 17.3% |
Space Separator
| Value | Count | Frequency (%) |
| 141497 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1371121 | |
| Common | 141497 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 282994 | |
| o | 190321 | |
| e | 190321 | |
| H | 141497 | |
| l | 141497 | |
| C | 92673 | 6.8% |
| i | 92673 | 6.8% |
| y | 92673 | 6.8% |
| R | 48824 | 3.6% |
| s | 48824 | 3.6% |
Common
| Value | Count | Frequency (%) |
| 141497 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1512618 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 282994 | |
| o | 190321 | |
| e | 190321 | |
| 141497 | ||
| H | 141497 | |
| l | 141497 | |
| C | 92673 | 6.1% |
| i | 92673 | 6.1% |
| y | 92673 | 6.1% |
| R | 48824 | 3.2% |
| Other values (2) | 97648 | 6.5% |
is_canceled
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141497 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141497 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141497 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141497 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 88775 | |
| 1 | 52722 |
lead_time
Real number (ℝ)
| Distinct | 479 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.89121 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 7756 |
| Zeros (%) | 5.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 17 |
| median | 68 |
| Q3 | 158 |
| 95-th percentile | 320 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 141 |
Descriptive statistics
| Standard deviation | 106.50491 |
|---|---|
| Coefficient of variation (CV) | 1.0351216 |
| Kurtosis | 1.4850697 |
| Mean | 102.89121 |
| Median Absolute Deviation (MAD) | 59 |
| Skewness | 1.3184629 |
| Sum | 14558797 |
| Variance | 11343.296 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7756 | 5.5% |
| 1 | 4129 | 2.9% |
| 2 | 2449 | 1.7% |
| 3 | 2187 | 1.5% |
| 4 | 2026 | 1.4% |
| 5 | 1922 | 1.4% |
| 6 | 1751 | 1.2% |
| 7 | 1548 | 1.1% |
| 8 | 1376 | 1.0% |
| 12 | 1356 | 1.0% |
| Other values (469) | 114997 |
| Value | Count | Frequency (%) |
| 0 | 7756 | |
| 1 | 4129 | |
| 2 | 2449 | 1.7% |
| 3 | 2187 | 1.5% |
| 4 | 2026 | 1.4% |
| 5 | 1922 | 1.4% |
| 6 | 1751 | 1.2% |
| 7 | 1548 | 1.1% |
| 8 | 1376 | 1.0% |
| 9 | 1143 | 0.8% |
| Value | Count | Frequency (%) |
| 737 | 2 | < 0.1% |
| 709 | 1 | < 0.1% |
| 629 | 17 | |
| 626 | 30 | |
| 622 | 17 | |
| 615 | 17 | |
| 608 | 17 | |
| 605 | 30 | |
| 601 | 17 | |
| 594 | 17 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 2019 | |
|---|---|
| 2020 | |
| 2018 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 565988 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2018 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2018 |
| 4th row | 2018 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2019 | 78989 | |
| 2020 | 40556 | |
| 2018 | 21952 | 15.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2019 | 78989 | |
| 2020 | 40556 | |
| 2018 | 21952 | 15.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 182053 | |
| 0 | 182053 | |
| 1 | 100941 | |
| 9 | 78989 | |
| 8 | 21952 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 565988 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 182053 | |
| 0 | 182053 | |
| 1 | 100941 | |
| 9 | 78989 | |
| 8 | 21952 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 565988 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 182053 | |
| 0 | 182053 | |
| 1 | 100941 | |
| 9 | 78989 | |
| 8 | 21952 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 565988 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 182053 | |
| 0 | 182053 | |
| 1 | 100941 | |
| 9 | 78989 | |
| 8 | 21952 | 3.9% |
arrival_date_month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| August | |
|---|---|
| October | |
| September | |
| July | |
| May | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.1029562 |
| Min length | 3 |
Characters and Unicode
| Total characters | 863550 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| August | 17714 | |
| October | 16090 | |
| September | 15606 | |
| July | 15394 | |
| May | 11764 | |
| April | 11057 | |
| June | 10917 | |
| March | 9765 | |
| December | 9752 | |
| November | 9117 | |
| Other values (2) | 14321 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| august | 17714 | |
| october | 16090 | |
| september | 15606 | |
| july | 15394 | |
| may | 11764 | |
| april | 11057 | |
| june | 10917 | |
| march | 9765 | |
| december | 9752 | |
| november | 9117 | |
| Other values (2) | 14321 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 129652 | |
| r | 94045 | 10.9% |
| u | 76060 | 8.8% |
| b | 58902 | 6.8% |
| t | 49410 | 5.7% |
| a | 41834 | 4.8% |
| y | 41479 | 4.8% |
| c | 35607 | 4.1% |
| m | 34475 | 4.0% |
| J | 32295 | 3.7% |
| Other values (16) | 269791 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 722053 | |
| Uppercase Letter | 141497 | 16.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 129652 | |
| r | 94045 | |
| u | 76060 | |
| b | 58902 | |
| t | 49410 | 6.8% |
| a | 41834 | 5.8% |
| y | 41479 | 5.7% |
| c | 35607 | 4.9% |
| m | 34475 | 4.8% |
| p | 26663 | 3.7% |
| Other values (8) | 133926 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 32295 | |
| A | 28771 | |
| M | 21529 | |
| O | 16090 | |
| S | 15606 | |
| D | 9752 | 6.9% |
| N | 9117 | 6.4% |
| F | 8337 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 863550 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 129652 | |
| r | 94045 | 10.9% |
| u | 76060 | 8.8% |
| b | 58902 | 6.8% |
| t | 49410 | 5.7% |
| a | 41834 | 4.8% |
| y | 41479 | 4.8% |
| c | 35607 | 4.1% |
| m | 34475 | 4.0% |
| J | 32295 | 3.7% |
| Other values (16) | 269791 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 863550 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 129652 | |
| r | 94045 | 10.9% |
| u | 76060 | 8.8% |
| b | 58902 | 6.8% |
| t | 49410 | 5.7% |
| a | 41834 | 4.8% |
| y | 41479 | 4.8% |
| c | 35607 | 4.1% |
| m | 34475 | 4.0% |
| J | 32295 | 3.7% |
| Other values (16) | 269791 |
arrival_date_week_number
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.043153 |
| Minimum | 1 |
|---|---|
| Maximum | 52 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 18 |
| median | 30 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 52 |
| Range | 51 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.566284 |
|---|---|
| Coefficient of variation (CV) | 0.46710783 |
| Kurtosis | -0.95472049 |
| Mean | 29.043153 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.21512561 |
| Sum | 4109519 |
| Variance | 184.04406 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 33 | 4732 | 3.3% |
| 52 | 4308 | 3.0% |
| 41 | 4095 | 2.9% |
| 38 | 4030 | 2.8% |
| 42 | 3967 | 2.8% |
| 32 | 3889 | 2.7% |
| 39 | 3878 | 2.7% |
| 30 | 3842 | 2.7% |
| 34 | 3797 | 2.7% |
| 29 | 3458 | 2.4% |
| Other values (42) | 101501 |
| Value | Count | Frequency (%) |
| 1 | 1053 | |
| 2 | 1244 | |
| 3 | 1322 | |
| 4 | 1494 | |
| 5 | 1397 | |
| 6 | 1557 | |
| 7 | 2238 | |
| 8 | 2236 | |
| 9 | 2176 | |
| 10 | 2165 |
| Value | Count | Frequency (%) |
| 52 | 4308 | |
| 51 | 1244 | 0.9% |
| 50 | 2103 | |
| 49 | 2619 | |
| 48 | 2111 | |
| 47 | 2361 | |
| 46 | 1993 | |
| 45 | 2488 | |
| 44 | 3132 | |
| 43 | 3283 |
arrival_date_day_of_month
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.747118 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7377653 |
|---|---|
| Coefficient of variation (CV) | 0.55488027 |
| Kurtosis | -1.1935398 |
| Mean | 15.747118 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.0049142173 |
| Sum | 2228170 |
| Variance | 76.348543 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=30)
| Value | Count | Frequency (%) |
| 28 | 8644 | 6.1% |
| 5 | 5493 | 3.9% |
| 17 | 5333 | 3.8% |
| 25 | 5035 | 3.6% |
| 18 | 4921 | 3.5% |
| 15 | 4913 | 3.5% |
| 9 | 4909 | 3.5% |
| 16 | 4907 | 3.5% |
| 12 | 4880 | 3.4% |
| 26 | 4810 | 3.4% |
| Other values (20) | 87652 |
| Value | Count | Frequency (%) |
| 1 | 4208 | |
| 2 | 4679 | |
| 3 | 4611 | |
| 4 | 4469 | |
| 5 | 5493 | |
| 6 | 4492 | |
| 7 | 4298 | |
| 8 | 4718 | |
| 9 | 4909 | |
| 10 | 4346 |
| Value | Count | Frequency (%) |
| 31 | 2731 | 1.9% |
| 30 | 4671 | |
| 28 | 8644 | |
| 27 | 4452 | |
| 26 | 4810 | |
| 25 | 5035 | |
| 24 | 4714 | |
| 23 | 4345 | |
| 22 | 4163 | |
| 21 | 4390 |
stays_in_weekend_nights
Real number (ℝ)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.92698078 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 61849 |
| Zeros (%) | 43.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.9977981 |
|---|---|
| Coefficient of variation (CV) | 1.0763957 |
| Kurtosis | 6.5532887 |
| Mean | 0.92698078 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3313081 |
| Sum | 131165 |
| Variance | 0.99560104 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 0 | 61849 | |
| 2 | 39644 | |
| 1 | 35897 | |
| 4 | 2202 | 1.6% |
| 3 | 1506 | 1.1% |
| 6 | 166 | 0.1% |
| 5 | 98 | 0.1% |
| 8 | 69 | < 0.1% |
| 7 | 31 | < 0.1% |
| 9 | 13 | < 0.1% |
| Other values (7) | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 61849 | |
| 1 | 35897 | |
| 2 | 39644 | |
| 3 | 1506 | 1.1% |
| 4 | 2202 | 1.6% |
| 5 | 98 | 0.1% |
| 6 | 166 | 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 69 | < 0.1% |
| 9 | 13 | < 0.1% |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 16 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 6 | < 0.1% |
| 10 | 7 | < 0.1% |
| 9 | 13 | < 0.1% |
| 8 | 69 | |
| 7 | 31 |
stays_in_week_nights
Real number (ℝ)
| Distinct | 33 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4944345 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 8790 |
| Zeros (%) | 6.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.9003186 |
|---|---|
| Coefficient of variation (CV) | 0.7618234 |
| Kurtosis | 22.318216 |
| Mean | 2.4944345 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.7683334 |
| Sum | 352955 |
| Variance | 3.6112107 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=33)
| Value | Count | Frequency (%) |
| 2 | 40730 | |
| 1 | 36341 | |
| 3 | 25529 | |
| 5 | 13087 | 9.2% |
| 4 | 11155 | 7.9% |
| 0 | 8790 | 6.2% |
| 6 | 1848 | 1.3% |
| 10 | 1244 | 0.9% |
| 7 | 1243 | 0.9% |
| 8 | 787 | 0.6% |
| Other values (23) | 743 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 8790 | 6.2% |
| 1 | 36341 | |
| 2 | 40730 | |
| 3 | 25529 | |
| 4 | 11155 | 7.9% |
| 5 | 13087 | 9.2% |
| 6 | 1848 | 1.3% |
| 7 | 1243 | 0.9% |
| 8 | 787 | 0.6% |
| 9 | 274 | 0.2% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 42 | 2 | < 0.1% |
| 40 | 2 | < 0.1% |
| 34 | 1 | < 0.1% |
| 33 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 5 | |
| 26 | 1 | < 0.1% |
| 25 | 6 | |
| 24 | 5 |
adults
Real number (ℝ)
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.858414 |
| Minimum | 1 |
|---|---|
| Maximum | 55 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 55 |
| Range | 54 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.62083386 |
|---|---|
| Coefficient of variation (CV) | 0.33406651 |
| Kurtosis | 1728.3002 |
| Mean | 1.858414 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.318421 |
| Sum | 262960 |
| Variance | 0.38543468 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 2 | 107167 | |
| 1 | 27564 | 19.5% |
| 3 | 6664 | 4.7% |
| 4 | 70 | < 0.1% |
| 26 | 10 | < 0.1% |
| 27 | 4 | < 0.1% |
| 20 | 4 | < 0.1% |
| 5 | 4 | < 0.1% |
| 40 | 2 | < 0.1% |
| 50 | 2 | < 0.1% |
| Other values (3) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 27564 | 19.5% |
| 2 | 107167 | |
| 3 | 6664 | 4.7% |
| 4 | 70 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 20 | 4 | < 0.1% |
| 26 | 10 | < 0.1% |
| 27 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 2 | < 0.1% |
| 50 | 2 | < 0.1% |
| 40 | 2 | < 0.1% |
| 27 | 4 | < 0.1% |
| 26 | 10 | < 0.1% |
| 20 | 4 | < 0.1% |
| 10 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5 | 4 | < 0.1% |
| 4 | 70 |
children
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 5354 |
| 2 | 3876 |
| 3 | 68 |
| 10 | 3 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000212 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141500 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 132196 | |
| 1 | 5354 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
| 10 | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 132196 | |
| 1 | 5354 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
| 10 | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 132199 | |
| 1 | 5357 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141500 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 132199 | |
| 1 | 5357 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141500 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 132199 | |
| 1 | 5357 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141500 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 132199 | |
| 1 | 5357 | 3.8% |
| 2 | 3876 | 2.7% |
| 3 | 68 | < 0.1% |
babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 1109 |
| 2 | 17 |
| 9 | 2 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.0000071 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141498 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 140368 | |
| 1 | 1109 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 140368 | |
| 1 | 1109 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 140369 | |
| 1 | 1110 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141498 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 140369 | |
| 1 | 1110 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141498 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 140369 | |
| 1 | 1110 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141498 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 140369 | |
| 1 | 1110 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
meal
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| BB | |
|---|---|
| HB | |
| SC | 10949 |
| FB | 1228 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 282994 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | HB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 110929 | |
| HB | 18391 | 13.0% |
| SC | 10949 | 7.7% |
| FB | 1228 | 0.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 110929 | |
| hb | 18391 | 13.0% |
| sc | 10949 | 7.7% |
| fb | 1228 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 241477 | |
| H | 18391 | 6.5% |
| S | 10949 | 3.9% |
| C | 10949 | 3.9% |
| F | 1228 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 282994 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 241477 | |
| H | 18391 | 6.5% |
| S | 10949 | 3.9% |
| C | 10949 | 3.9% |
| F | 1228 | 0.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 282994 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 241477 | |
| H | 18391 | 6.5% |
| S | 10949 | 3.9% |
| C | 10949 | 3.9% |
| F | 1228 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 282994 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 241477 | |
| H | 18391 | 6.5% |
| S | 10949 | 3.9% |
| C | 10949 | 3.9% |
| F | 1228 | 0.4% |
country
Categorical
HIGH CARDINALITY IMBALANCE
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (172) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 424491 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | PRT |
| 4th row | PRT |
| 5th row | PRT |
Common Values
| Value | Count | Frequency (%) |
| PRT | 62822 | |
| GBR | 13461 | 9.5% |
| FRA | 11746 | 8.3% |
| ESP | 10493 | 7.4% |
| DEU | 7796 | 5.5% |
| ITA | 4304 | 3.0% |
| IRL | 3855 | 2.7% |
| BEL | 2537 | 1.8% |
| BRA | 2361 | 1.7% |
| NLD | 2294 | 1.6% |
| Other values (167) | 19828 | 14.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| prt | 62822 | |
| gbr | 13461 | 9.5% |
| fra | 11746 | 8.3% |
| esp | 10493 | 7.4% |
| deu | 7796 | 5.5% |
| ita | 4304 | 3.0% |
| irl | 3855 | 2.7% |
| bel | 2537 | 1.8% |
| bra | 2361 | 1.7% |
| nld | 2294 | 1.6% |
| Other values (167) | 19828 | 14.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 98795 | |
| P | 74793 | |
| T | 69197 | |
| A | 25484 | 6.0% |
| E | 24481 | 5.8% |
| B | 18746 | 4.4% |
| S | 16428 | 3.9% |
| G | 14569 | 3.4% |
| U | 14354 | 3.4% |
| F | 12329 | 2.9% |
| Other values (16) | 55315 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 424491 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 98795 | |
| P | 74793 | |
| T | 69197 | |
| A | 25484 | 6.0% |
| E | 24481 | 5.8% |
| B | 18746 | 4.4% |
| S | 16428 | 3.9% |
| G | 14569 | 3.4% |
| U | 14354 | 3.4% |
| F | 12329 | 2.9% |
| Other values (16) | 55315 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 424491 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 98795 | |
| P | 74793 | |
| T | 69197 | |
| A | 25484 | 6.0% |
| E | 24481 | 5.8% |
| B | 18746 | 4.4% |
| S | 16428 | 3.9% |
| G | 14569 | 3.4% |
| U | 14354 | 3.4% |
| F | 12329 | 2.9% |
| Other values (16) | 55315 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 424491 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 98795 | |
| P | 74793 | |
| T | 69197 | |
| A | 25484 | 6.0% |
| E | 24481 | 5.8% |
| B | 18746 | 4.4% |
| S | 16428 | 3.9% |
| G | 14569 | 3.4% |
| U | 14354 | 3.4% |
| F | 12329 | 2.9% |
| Other values (16) | 55315 |
market_segment
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | |
| Other values (2) | 1126 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.0117176 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1275131 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Online TA |
|---|---|
| 2nd row | Offline TA/TO |
| 3rd row | Online TA |
| 4th row | Online TA |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 62575 | |
| Offline TA/TO | 30330 | |
| Groups | 26086 | |
| Direct | 14911 | 10.5% |
| Corporate | 6469 | 4.6% |
| Complementary | 891 | 0.6% |
| Aviation | 235 | 0.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 62575 | |
| ta | 62575 | |
| offline | 30330 | |
| ta/to | 30330 | |
| groups | 26086 | |
| direct | 14911 | 6.4% |
| corporate | 6469 | 2.8% |
| complementary | 891 | 0.4% |
| aviation | 235 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 156606 | |
| O | 123235 | |
| T | 123235 | |
| e | 116067 | |
| i | 108286 | |
| l | 93796 | 7.4% |
| A | 93140 | 7.3% |
| 92905 | 7.3% | |
| f | 60660 | 4.8% |
| r | 54826 | 4.3% |
| Other values (14) | 252375 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 763929 | |
| Uppercase Letter | 387967 | |
| Space Separator | 92905 | 7.3% |
| Other Punctuation | 30330 | 2.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 156606 | |
| e | 116067 | |
| i | 108286 | |
| l | 93796 | |
| f | 60660 | 7.9% |
| r | 54826 | 7.2% |
| o | 40150 | 5.3% |
| p | 33446 | 4.4% |
| u | 26086 | 3.4% |
| s | 26086 | 3.4% |
| Other values (6) | 47920 | 6.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 123235 | |
| T | 123235 | |
| A | 93140 | |
| G | 26086 | 6.7% |
| D | 14911 | 3.8% |
| C | 7360 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 92905 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 30330 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1151896 | |
| Common | 123235 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 156606 | |
| O | 123235 | |
| T | 123235 | |
| e | 116067 | |
| i | 108286 | |
| l | 93796 | |
| A | 93140 | |
| f | 60660 | 5.3% |
| r | 54826 | 4.8% |
| o | 40150 | 3.5% |
| Other values (12) | 181895 |
Common
| Value | Count | Frequency (%) |
| 92905 | ||
| / | 30330 | 24.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1275131 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 156606 | |
| O | 123235 | |
| T | 123235 | |
| e | 116067 | |
| i | 108286 | |
| l | 93796 | 7.4% |
| A | 93140 | 7.3% |
| 92905 | 7.3% | |
| f | 60660 | 4.8% |
| r | 54826 | 4.3% |
| Other values (14) | 252375 |
distribution_channel
Categorical
HIGH CORRELATION IMBALANCE
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 8135 |
| GDS | 194 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.3505657 |
| Min length | 3 |
Characters and Unicode
| Total characters | 757089 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TA/TO |
|---|---|
| 2nd row | TA/TO |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 115716 | |
| Direct | 17452 | 12.3% |
| Corporate | 8135 | 5.7% |
| GDS | 194 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 115716 | |
| direct | 17452 | 12.3% |
| corporate | 8135 | 5.7% |
| gds | 194 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 231432 | |
| A | 115716 | |
| / | 115716 | |
| O | 115716 | |
| r | 33722 | 4.5% |
| e | 25587 | 3.4% |
| t | 25587 | 3.4% |
| D | 17646 | 2.3% |
| i | 17452 | 2.3% |
| c | 17452 | 2.3% |
| Other values (6) | 41063 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 489033 | |
| Lowercase Letter | 152340 | 20.1% |
| Other Punctuation | 115716 | 15.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 33722 | |
| e | 25587 | |
| t | 25587 | |
| i | 17452 | |
| c | 17452 | |
| o | 16270 | |
| p | 8135 | 5.3% |
| a | 8135 | 5.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 231432 | |
| A | 115716 | |
| O | 115716 | |
| D | 17646 | 3.6% |
| C | 8135 | 1.7% |
| G | 194 | < 0.1% |
| S | 194 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 115716 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 641373 | |
| Common | 115716 | 15.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 231432 | |
| A | 115716 | |
| O | 115716 | |
| r | 33722 | 5.3% |
| e | 25587 | 4.0% |
| t | 25587 | 4.0% |
| D | 17646 | 2.8% |
| i | 17452 | 2.7% |
| c | 17452 | 2.7% |
| o | 16270 | 2.5% |
| Other values (5) | 24793 | 3.9% |
Common
| Value | Count | Frequency (%) |
| / | 115716 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 757089 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 231432 | |
| A | 115716 | |
| / | 115716 | |
| O | 115716 | |
| r | 33722 | 4.5% |
| e | 25587 | 3.4% |
| t | 25587 | 3.4% |
| D | 17646 | 2.3% |
| i | 17452 | 2.3% |
| c | 17452 | 2.3% |
| Other values (6) | 41063 | 5.4% |
is_repeated_guest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 4386 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141497 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141497 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141497 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141497 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 137111 | |
| 1 | 4386 | 3.1% |
previous_cancellations
Real number (ℝ)
SKEWED ZEROS
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12574118 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 130585 |
| Zeros (%) | 92.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0612524 |
|---|---|
| Coefficient of variation (CV) | 8.4399748 |
| Kurtosis | 447.09019 |
| Mean | 0.12574118 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.199107 |
| Sum | 17792 |
| Variance | 1.1262567 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 0 | 130585 | |
| 1 | 10307 | 7.3% |
| 2 | 145 | 0.1% |
| 24 | 96 | 0.1% |
| 3 | 73 | 0.1% |
| 26 | 52 | < 0.1% |
| 25 | 50 | < 0.1% |
| 19 | 38 | < 0.1% |
| 11 | 37 | < 0.1% |
| 4 | 31 | < 0.1% |
| Other values (5) | 83 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 130585 | |
| 1 | 10307 | 7.3% |
| 2 | 145 | 0.1% |
| 3 | 73 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 22 | < 0.1% |
| 11 | 37 | < 0.1% |
| 13 | 12 | < 0.1% |
| 14 | 28 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 52 | |
| 25 | 50 | |
| 24 | 96 | |
| 21 | 2 | < 0.1% |
| 19 | 38 | < 0.1% |
| 14 | 28 | < 0.1% |
| 13 | 12 | < 0.1% |
| 11 | 37 | < 0.1% |
| 6 | 22 | < 0.1% |
| 5 | 19 | < 0.1% |
previous_bookings_not_canceled
Real number (ℝ)
SKEWED ZEROS
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12049725 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 137569 |
| Zeros (%) | 97.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3835765 |
|---|---|
| Coefficient of variation (CV) | 11.482224 |
| Kurtosis | 890.29367 |
| Mean | 0.12049725 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.270123 |
| Sum | 17050 |
| Variance | 1.914284 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 137569 | |
| 1 | 1714 | 1.2% |
| 2 | 642 | 0.5% |
| 3 | 361 | 0.3% |
| 4 | 240 | 0.2% |
| 5 | 192 | 0.1% |
| 6 | 120 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 74 | 0.1% |
| 9 | 62 | < 0.1% |
| Other values (63) | 429 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 137569 | |
| 1 | 1714 | 1.2% |
| 2 | 642 | 0.5% |
| 3 | 361 | 0.3% |
| 4 | 240 | 0.2% |
| 5 | 192 | 0.1% |
| 6 | 120 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 74 | 0.1% |
| 9 | 62 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
booking_changes
Real number (ℝ)
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2113543 |
| Minimum | 0 |
|---|---|
| Maximum | 18 |
| Zeros | 120590 |
| Zeros (%) | 85.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.62108295 |
|---|---|
| Coefficient of variation (CV) | 2.9385867 |
| Kurtosis | 65.243583 |
| Mean | 0.2113543 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.5266573 |
| Sum | 29906 |
| Variance | 0.38574404 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=19)
| Value | Count | Frequency (%) |
| 0 | 120590 | |
| 1 | 14969 | 10.6% |
| 2 | 4235 | 3.0% |
| 3 | 1027 | 0.7% |
| 4 | 404 | 0.3% |
| 5 | 132 | 0.1% |
| 6 | 62 | < 0.1% |
| 7 | 30 | < 0.1% |
| 8 | 15 | < 0.1% |
| 9 | 8 | < 0.1% |
| Other values (9) | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 120590 | |
| 1 | 14969 | 10.6% |
| 2 | 4235 | 3.0% |
| 3 | 1027 | 0.7% |
| 4 | 404 | 0.3% |
| 5 | 132 | 0.1% |
| 6 | 62 | < 0.1% |
| 7 | 30 | < 0.1% |
| 8 | 15 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 18 | 1 | < 0.1% |
| 17 | 3 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 3 | < 0.1% |
| 14 | 3 | < 0.1% |
| 13 | 5 | |
| 12 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 10 | 6 | |
| 9 | 8 |
deposit_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 166 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1414970 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 122947 | |
| Non Refund | 18384 | 13.0% |
| Refundable | 166 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 122947 | |
| deposit | 122947 | |
| non | 18384 | 6.5% |
| refund | 18384 | 6.5% |
| refundable | 166 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 264278 | |
| e | 141663 | |
| N | 141331 | |
| 141331 | ||
| s | 122947 | |
| i | 122947 | |
| t | 122947 | |
| p | 122947 | |
| D | 122947 | |
| n | 36934 | 2.6% |
| Other values (7) | 74698 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 990811 | |
| Uppercase Letter | 282828 | 20.0% |
| Space Separator | 141331 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 264278 | |
| e | 141663 | |
| s | 122947 | |
| i | 122947 | |
| t | 122947 | |
| p | 122947 | |
| n | 36934 | 3.7% |
| f | 18550 | 1.9% |
| u | 18550 | 1.9% |
| d | 18550 | 1.9% |
| Other values (3) | 498 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 141331 | |
| D | 122947 | |
| R | 18550 | 6.6% |
Space Separator
| Value | Count | Frequency (%) |
| 141331 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1273639 | |
| Common | 141331 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 264278 | |
| e | 141663 | |
| N | 141331 | |
| s | 122947 | |
| i | 122947 | |
| t | 122947 | |
| p | 122947 | |
| D | 122947 | |
| n | 36934 | 2.9% |
| R | 18550 | 1.5% |
| Other values (6) | 56148 | 4.4% |
Common
| Value | Count | Frequency (%) |
| 141331 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1414970 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 264278 | |
| e | 141663 | |
| N | 141331 | |
| 141331 | ||
| s | 122947 | |
| i | 122947 | |
| t | 122947 | |
| p | 122947 | |
| D | 122947 | |
| n | 36934 | 2.6% |
| Other values (7) | 74698 | 5.3% |
agent
Categorical
| Distinct | 334 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 9 | |
|---|---|
| No Agent | |
| 240 | |
| 1 | |
| 6 | 4506 |
| Other values (329) |
Length
| Max length | 8 |
|---|---|
| Median length | 3 |
| Mean length | 2.6862478 |
| Min length | 1 |
Characters and Unicode
| Total characters | 380096 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 40 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 240 |
|---|---|
| 2nd row | 15 |
| 3rd row | 240 |
| 4th row | 240 |
| 5th row | No Agent |
Common Values
| Value | Count | Frequency (%) |
| 9 | 34069 | |
| No Agent | 19459 | |
| 240 | 16686 | |
| 1 | 11387 | 8.0% |
| 6 | 4506 | 3.2% |
| 14 | 3996 | 2.8% |
| 7 | 3865 | 2.7% |
| 250 | 3357 | 2.4% |
| 241 | 2052 | 1.5% |
| 28 | 1964 | 1.4% |
| Other values (324) | 40156 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 9 | 34069 | |
| no | 19459 | |
| agent | 19459 | |
| 240 | 16686 | 10.4% |
| 1 | 11387 | 7.1% |
| 6 | 4506 | 2.8% |
| 14 | 3996 | 2.5% |
| 7 | 3865 | 2.4% |
| 250 | 3357 | 2.1% |
| 241 | 2052 | 1.3% |
| Other values (325) | 42120 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 41339 | 10.9% |
| 2 | 38859 | 10.2% |
| 1 | 35086 | 9.2% |
| 4 | 31908 | 8.4% |
| 0 | 24506 | 6.4% |
| o | 19459 | 5.1% |
| 19459 | 5.1% | |
| A | 19459 | 5.1% |
| g | 19459 | 5.1% |
| e | 19459 | 5.1% |
| Other values (8) | 111103 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 224424 | |
| Lowercase Letter | 97295 | |
| Uppercase Letter | 38918 | 10.2% |
| Space Separator | 19459 | 5.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 41339 | |
| 2 | 38859 | |
| 1 | 35086 | |
| 4 | 31908 | |
| 0 | 24506 | |
| 3 | 12983 | 5.8% |
| 7 | 10224 | 4.6% |
| 5 | 10046 | 4.5% |
| 6 | 9798 | 4.4% |
| 8 | 9675 | 4.3% |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 19459 | |
| g | 19459 | |
| e | 19459 | |
| n | 19459 | |
| t | 19459 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 19459 | |
| N | 19459 |
Space Separator
| Value | Count | Frequency (%) |
| 19459 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 243883 | |
| Latin | 136213 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 41339 | |
| 2 | 38859 | |
| 1 | 35086 | |
| 4 | 31908 | |
| 0 | 24506 | |
| 19459 | ||
| 3 | 12983 | 5.3% |
| 7 | 10224 | 4.2% |
| 5 | 10046 | 4.1% |
| 6 | 9798 | 4.0% |
Latin
| Value | Count | Frequency (%) |
| o | 19459 | |
| A | 19459 | |
| g | 19459 | |
| e | 19459 | |
| n | 19459 | |
| t | 19459 | |
| N | 19459 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 380096 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 41339 | 10.9% |
| 2 | 38859 | 10.2% |
| 1 | 35086 | 9.2% |
| 4 | 31908 | 8.4% |
| 0 | 24506 | 6.4% |
| o | 19459 | 5.1% |
| 19459 | 5.1% | |
| A | 19459 | 5.1% |
| g | 19459 | 5.1% |
| e | 19459 | 5.1% |
| Other values (8) | 111103 |
days_in_waiting_list
Real number (ℝ)
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3082751 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 137057 |
| Zeros (%) | 96.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16.950155 |
|---|---|
| Coefficient of variation (CV) | 7.3432126 |
| Kurtosis | 185.28278 |
| Mean | 2.3082751 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.707462 |
| Sum | 326614 |
| Variance | 287.30775 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 137057 | |
| 58 | 328 | 0.2% |
| 39 | 227 | 0.2% |
| 87 | 160 | 0.1% |
| 44 | 141 | 0.1% |
| 31 | 127 | 0.1% |
| 69 | 125 | 0.1% |
| 50 | 110 | 0.1% |
| 122 | 105 | 0.1% |
| 77 | 101 | 0.1% |
| Other values (117) | 3016 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 137057 | |
| 1 | 12 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 59 | < 0.1% |
| 4 | 25 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 25 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 | |
| 224 | 10 | < 0.1% |
| 223 | 61 | |
| 215 | 21 | < 0.1% |
| 207 | 15 | < 0.1% |
| 193 | 1 | < 0.1% |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 6738 |
| Group | 767 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.322092 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1460545 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 101179 | |
| Transient-Party | 32813 | 23.2% |
| Contract | 6738 | 4.8% |
| Group | 767 | 0.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 101179 | |
| transient-party | 32813 | 23.2% |
| contract | 6738 | 4.8% |
| group | 767 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 274722 | |
| t | 180281 | |
| r | 174310 | |
| a | 173543 | |
| T | 133992 | |
| s | 133992 | |
| i | 133992 | |
| e | 133992 | |
| y | 32813 | 2.2% |
| - | 32813 | 2.2% |
| Other values (7) | 56095 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1253422 | |
| Uppercase Letter | 174310 | 11.9% |
| Dash Punctuation | 32813 | 2.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 274722 | |
| t | 180281 | |
| r | 174310 | |
| a | 173543 | |
| s | 133992 | |
| i | 133992 | |
| e | 133992 | |
| y | 32813 | 2.6% |
| o | 7505 | 0.6% |
| c | 6738 | 0.5% |
| Other values (2) | 1534 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 133992 | |
| P | 32813 | 18.8% |
| C | 6738 | 3.9% |
| G | 767 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 32813 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1427732 | |
| Common | 32813 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 274722 | |
| t | 180281 | |
| r | 174310 | |
| a | 173543 | |
| T | 133992 | |
| s | 133992 | |
| i | 133992 | |
| e | 133992 | |
| y | 32813 | 2.3% |
| P | 32813 | 2.3% |
| Other values (6) | 23282 | 1.6% |
Common
| Value | Count | Frequency (%) |
| - | 32813 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1460545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 274722 | |
| t | 180281 | |
| r | 174310 | |
| a | 173543 | |
| T | 133992 | |
| s | 133992 | |
| i | 133992 | |
| e | 133992 | |
| y | 32813 | 2.2% |
| - | 32813 | 2.2% |
| Other values (7) | 56095 | 3.8% |
adr
Real number (ℝ)
| Distinct | 8857 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.549352 |
| Minimum | 0 |
|---|---|
| Maximum | 510 |
| Zeros | 2369 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 37.8 |
| Q1 | 66 |
| median | 90.95 |
| Q3 | 123 |
| 95-th percentile | 190 |
| Maximum | 510 |
| Range | 510 |
| Interquartile range (IQR) | 57 |
Descriptive statistics
| Standard deviation | 47.542653 |
|---|---|
| Coefficient of variation (CV) | 0.47757872 |
| Kurtosis | 2.1441516 |
| Mean | 99.549352 |
| Median Absolute Deviation (MAD) | 27.55 |
| Skewness | 1.0318292 |
| Sum | 14085935 |
| Variance | 2260.3038 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 62 | 6172 | 4.4% |
| 75 | 3251 | 2.3% |
| 90 | 3050 | 2.2% |
| 65 | 2997 | 2.1% |
| 0 | 2369 | 1.7% |
| 80 | 2181 | 1.5% |
| 60 | 1859 | 1.3% |
| 100 | 1856 | 1.3% |
| 95 | 1777 | 1.3% |
| 120 | 1730 | 1.2% |
| Other values (8847) | 114255 |
| Value | Count | Frequency (%) |
| 0 | 2369 | |
| 0.26 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 1 | 14 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.6 | 2 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 2 | 13 | < 0.1% |
| 2.4 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 510 | 1 | |
| 508 | 2 | |
| 451.5 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 | |
| 388 | 2 |
required_car_parking_spaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 8721 |
| 2 | 32 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141497 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141497 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141497 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141497 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 132739 | |
| 1 | 8721 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
total_of_special_requests
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54905051 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 85808 |
| Zeros (%) | 60.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.78620746 |
|---|---|
| Coefficient of variation (CV) | 1.4319401 |
| Kurtosis | 1.5825783 |
| Mean | 0.54905051 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3959754 |
| Sum | 77689 |
| Variance | 0.61812217 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 0 | 85808 | |
| 1 | 37411 | |
| 2 | 15004 | 10.6% |
| 3 | 2870 | 2.0% |
| 4 | 360 | 0.3% |
| 5 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 85808 | |
| 1 | 37411 | |
| 2 | 15004 | 10.6% |
| 3 | 2870 | 2.0% |
| 4 | 360 | 0.3% |
| 5 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 44 | < 0.1% |
| 4 | 360 | 0.3% |
| 3 | 2870 | 2.0% |
| 2 | 15004 | 10.6% |
| 1 | 37411 | |
| 0 | 85808 |
reservation_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1465 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6176809 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1219376 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Canceled |
|---|---|
| 2nd row | Canceled |
| 3rd row | Canceled |
| 4th row | Canceled |
| 5th row | Canceled |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 88865 | |
| Canceled | 51167 | |
| No-Show | 1465 | 1.0% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 88865 | |
| canceled | 51167 | |
| no-show | 1465 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 191199 | |
| C | 140032 | |
| c | 140032 | |
| h | 90330 | |
| - | 90330 | |
| u | 88865 | |
| t | 88865 | |
| O | 88865 | |
| k | 88865 | |
| a | 51167 | 4.2% |
| Other values (7) | 160826 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 897219 | |
| Uppercase Letter | 231827 | 19.0% |
| Dash Punctuation | 90330 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 191199 | |
| c | 140032 | |
| h | 90330 | |
| u | 88865 | |
| t | 88865 | |
| k | 88865 | |
| a | 51167 | 5.7% |
| n | 51167 | 5.7% |
| l | 51167 | 5.7% |
| d | 51167 | 5.7% |
| Other values (2) | 4395 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 140032 | |
| O | 88865 | |
| N | 1465 | 0.6% |
| S | 1465 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 90330 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1129046 | |
| Common | 90330 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 191199 | |
| C | 140032 | |
| c | 140032 | |
| h | 90330 | |
| u | 88865 | |
| t | 88865 | |
| O | 88865 | |
| k | 88865 | |
| a | 51167 | 4.5% |
| n | 51167 | 4.5% |
| Other values (6) | 109659 |
Common
| Value | Count | Frequency (%) |
| - | 90330 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1219376 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 191199 | |
| C | 140032 | |
| c | 140032 | |
| h | 90330 | |
| - | 90330 | |
| u | 88865 | |
| t | 88865 | |
| O | 88865 | |
| k | 88865 | |
| a | 51167 | 4.2% |
| Other values (7) | 160826 |
| lead_time | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | previous_cancellations | previous_bookings_not_canceled | booking_changes | days_in_waiting_list | adr | total_of_special_requests | hotel | is_canceled | arrival_date_year | arrival_date_month | children | babies | meal | market_segment | distribution_channel | is_repeated_guest | deposit_type | customer_type | required_car_parking_spaces | reservation_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lead_time | 1.000 | 0.043 | 0.001 | 0.155 | 0.276 | 0.194 | 0.235 | -0.181 | -0.019 | 0.137 | -0.008 | -0.092 | 0.105 | 0.308 | 0.099 | 0.129 | 0.030 | 0.010 | 0.099 | 0.187 | 0.134 | 0.121 | 0.287 | 0.131 | 0.058 | 0.227 |
| arrival_date_week_number | 0.043 | 1.000 | 0.064 | 0.007 | 0.002 | -0.014 | 0.116 | -0.039 | 0.006 | 0.017 | -0.032 | -0.013 | 0.079 | 0.071 | 0.405 | 0.839 | 0.063 | 0.018 | 0.088 | 0.092 | 0.083 | 0.066 | 0.110 | 0.117 | 0.019 | 0.064 |
| arrival_date_day_of_month | 0.001 | 0.064 | 1.000 | -0.016 | -0.014 | 0.006 | -0.020 | 0.000 | 0.012 | 0.042 | 0.034 | 0.007 | 0.033 | 0.021 | 0.037 | 0.065 | 0.013 | 0.006 | 0.048 | 0.044 | 0.036 | 0.022 | 0.063 | 0.040 | 0.010 | 0.025 |
| stays_in_weekend_nights | 0.155 | 0.007 | -0.016 | 1.000 | 0.237 | 0.131 | -0.055 | -0.080 | 0.037 | -0.077 | 0.053 | 0.081 | 0.202 | 0.022 | 0.023 | 0.047 | 0.031 | 0.011 | 0.066 | 0.063 | 0.064 | 0.081 | 0.074 | 0.075 | 0.012 | 0.023 |
| stays_in_week_nights | 0.276 | 0.002 | -0.014 | 0.237 | 1.000 | 0.148 | -0.070 | -0.115 | 0.066 | 0.018 | 0.106 | 0.091 | 0.199 | 0.031 | 0.011 | 0.036 | 0.016 | 0.000 | 0.047 | 0.038 | 0.010 | 0.019 | 0.049 | 0.071 | 0.015 | 0.031 |
| adults | 0.194 | -0.014 | 0.006 | 0.131 | 0.148 | 1.000 | -0.022 | -0.204 | -0.086 | -0.032 | 0.262 | 0.164 | 0.018 | 0.017 | 0.008 | 0.012 | 0.000 | 0.000 | 0.000 | 0.012 | 0.013 | 0.000 | 0.000 | 0.106 | 0.000 | 0.011 |
| previous_cancellations | 0.235 | 0.116 | -0.020 | -0.055 | -0.070 | -0.022 | 1.000 | 0.068 | -0.090 | 0.061 | -0.171 | -0.157 | 0.062 | 0.056 | 0.034 | 0.036 | 0.003 | 0.000 | 0.116 | 0.055 | 0.059 | 0.170 | 0.064 | 0.011 | 0.000 | 0.040 |
| previous_bookings_not_canceled | -0.181 | -0.039 | 0.000 | -0.080 | -0.115 | -0.204 | 0.068 | 1.000 | 0.031 | -0.020 | -0.132 | 0.025 | 0.016 | 0.039 | 0.024 | 0.018 | 0.000 | 0.000 | 0.015 | 0.096 | 0.114 | 0.302 | 0.013 | 0.015 | 0.016 | 0.028 |
| booking_changes | -0.019 | 0.006 | 0.012 | 0.037 | 0.066 | -0.086 | -0.090 | 0.031 | 1.000 | -0.013 | 0.012 | 0.045 | 0.050 | 0.083 | 0.028 | 0.014 | 0.027 | 0.025 | 0.011 | 0.034 | 0.051 | 0.000 | 0.057 | 0.034 | 0.027 | 0.061 |
| days_in_waiting_list | 0.137 | 0.017 | 0.042 | -0.077 | 0.018 | -0.032 | 0.061 | -0.020 | -0.013 | 1.000 | -0.028 | -0.121 | 0.092 | 0.049 | 0.065 | 0.065 | 0.018 | 0.000 | 0.034 | 0.081 | 0.032 | 0.025 | 0.105 | 0.081 | 0.031 | 0.038 |
| adr | -0.008 | -0.032 | 0.034 | 0.053 | 0.106 | 0.262 | -0.171 | -0.132 | 0.012 | -0.028 | 1.000 | 0.206 | 0.410 | 0.103 | 0.142 | 0.166 | 0.199 | 0.020 | 0.111 | 0.189 | 0.149 | 0.150 | 0.119 | 0.125 | 0.050 | 0.074 |
| total_of_special_requests | -0.092 | -0.013 | 0.007 | 0.081 | 0.091 | 0.164 | -0.157 | 0.025 | 0.045 | -0.121 | 0.206 | 1.000 | 0.067 | 0.258 | 0.087 | 0.053 | 0.065 | 0.064 | 0.070 | 0.221 | 0.079 | 0.038 | 0.220 | 0.118 | 0.047 | 0.184 |
| hotel | 0.105 | 0.079 | 0.033 | 0.202 | 0.199 | 0.018 | 0.062 | 0.016 | 0.050 | 0.092 | 0.410 | 0.067 | 1.000 | 0.137 | 0.036 | 0.085 | 0.058 | 0.050 | 0.272 | 0.155 | 0.193 | 0.034 | 0.179 | 0.067 | 0.223 | 0.139 |
| is_canceled | 0.308 | 0.071 | 0.021 | 0.022 | 0.031 | 0.017 | 0.056 | 0.039 | 0.083 | 0.049 | 0.103 | 0.258 | 0.137 | 1.000 | 0.019 | 0.073 | 0.029 | 0.035 | 0.051 | 0.280 | 0.174 | 0.062 | 0.497 | 0.112 | 0.198 | 0.999 |
| arrival_date_year | 0.099 | 0.405 | 0.037 | 0.023 | 0.011 | 0.008 | 0.034 | 0.024 | 0.028 | 0.065 | 0.142 | 0.087 | 0.036 | 0.019 | 1.000 | 0.403 | 0.043 | 0.008 | 0.106 | 0.142 | 0.024 | 0.010 | 0.046 | 0.167 | 0.015 | 0.019 |
| arrival_date_month | 0.129 | 0.839 | 0.065 | 0.047 | 0.036 | 0.012 | 0.036 | 0.018 | 0.014 | 0.065 | 0.166 | 0.053 | 0.085 | 0.073 | 0.403 | 1.000 | 0.066 | 0.019 | 0.093 | 0.102 | 0.086 | 0.068 | 0.104 | 0.124 | 0.020 | 0.066 |
| children | 0.030 | 0.063 | 0.013 | 0.031 | 0.016 | 0.000 | 0.003 | 0.000 | 0.027 | 0.018 | 0.199 | 0.065 | 0.058 | 0.029 | 0.043 | 0.066 | 1.000 | 0.025 | 0.035 | 0.100 | 0.050 | 0.031 | 0.072 | 0.068 | 0.033 | 0.038 |
| babies | 0.010 | 0.018 | 0.006 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.025 | 0.000 | 0.020 | 0.064 | 0.050 | 0.035 | 0.008 | 0.019 | 0.025 | 1.000 | 0.017 | 0.036 | 0.034 | 0.009 | 0.024 | 0.017 | 0.021 | 0.024 |
| meal | 0.099 | 0.088 | 0.048 | 0.066 | 0.047 | 0.000 | 0.116 | 0.015 | 0.011 | 0.034 | 0.111 | 0.070 | 0.272 | 0.051 | 0.106 | 0.093 | 0.035 | 0.017 | 1.000 | 0.216 | 0.085 | 0.063 | 0.094 | 0.127 | 0.027 | 0.042 |
| market_segment | 0.187 | 0.092 | 0.044 | 0.063 | 0.038 | 0.012 | 0.055 | 0.096 | 0.034 | 0.081 | 0.189 | 0.221 | 0.155 | 0.280 | 0.142 | 0.102 | 0.100 | 0.036 | 0.216 | 1.000 | 0.712 | 0.319 | 0.364 | 0.285 | 0.094 | 0.206 |
| distribution_channel | 0.134 | 0.083 | 0.036 | 0.064 | 0.010 | 0.013 | 0.059 | 0.114 | 0.051 | 0.032 | 0.149 | 0.079 | 0.193 | 0.174 | 0.024 | 0.086 | 0.050 | 0.034 | 0.085 | 0.712 | 1.000 | 0.270 | 0.090 | 0.089 | 0.086 | 0.129 |
| is_repeated_guest | 0.121 | 0.066 | 0.022 | 0.081 | 0.019 | 0.000 | 0.170 | 0.302 | 0.000 | 0.025 | 0.150 | 0.038 | 0.034 | 0.062 | 0.010 | 0.068 | 0.031 | 0.009 | 0.063 | 0.319 | 0.270 | 1.000 | 0.054 | 0.088 | 0.065 | 0.063 |
| deposit_type | 0.287 | 0.110 | 0.063 | 0.074 | 0.049 | 0.000 | 0.064 | 0.013 | 0.057 | 0.105 | 0.119 | 0.220 | 0.179 | 0.497 | 0.046 | 0.104 | 0.072 | 0.024 | 0.094 | 0.364 | 0.090 | 0.054 | 1.000 | 0.086 | 0.073 | 0.357 |
| customer_type | 0.131 | 0.117 | 0.040 | 0.075 | 0.071 | 0.106 | 0.011 | 0.015 | 0.034 | 0.081 | 0.125 | 0.118 | 0.067 | 0.112 | 0.167 | 0.124 | 0.068 | 0.017 | 0.127 | 0.285 | 0.089 | 0.088 | 0.086 | 1.000 | 0.049 | 0.079 |
| required_car_parking_spaces | 0.058 | 0.019 | 0.010 | 0.012 | 0.015 | 0.000 | 0.000 | 0.016 | 0.027 | 0.031 | 0.050 | 0.047 | 0.223 | 0.198 | 0.015 | 0.020 | 0.033 | 0.021 | 0.027 | 0.094 | 0.086 | 0.065 | 0.073 | 0.049 | 1.000 | 0.140 |
| reservation_status | 0.227 | 0.064 | 0.025 | 0.023 | 0.031 | 0.011 | 0.040 | 0.028 | 0.061 | 0.038 | 0.074 | 0.184 | 0.139 | 0.999 | 0.019 | 0.066 | 0.038 | 0.024 | 0.042 | 0.206 | 0.129 | 0.063 | 0.357 | 0.079 | 0.140 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | booking_changes | deposit_type | agent | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Resort Hotel | 1 | 85 | 2018 | July | 27 | 1 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 240 | 0 | Transient | 82.00 | 0 | 1 | Canceled |
| 1 | Resort Hotel | 1 | 75 | 2018 | July | 27 | 1 | 0 | 3 | 2 | 0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 15 | 0 | Transient | 105.50 | 0 | 0 | Canceled |
| 2 | Resort Hotel | 1 | 23 | 2018 | July | 27 | 1 | 0 | 4 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 240 | 0 | Transient | 123.00 | 0 | 0 | Canceled |
| 3 | Resort Hotel | 1 | 60 | 2018 | July | 27 | 1 | 2 | 5 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 240 | 0 | Transient | 107.00 | 0 | 2 | Canceled |
| 4 | Resort Hotel | 1 | 96 | 2018 | July | 27 | 1 | 2 | 8 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | 0 | No Deposit | No Agent | 0 | Transient | 108.30 | 0 | 2 | Canceled |
| 5 | Resort Hotel | 1 | 45 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 241 | 0 | Transient | 108.80 | 0 | 1 | Canceled |
| 6 | Resort Hotel | 1 | 40 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 241 | 0 | Transient | 108.80 | 0 | 1 | Canceled |
| 7 | Resort Hotel | 1 | 43 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 241 | 0 | Transient | 108.80 | 0 | 0 | Canceled |
| 8 | Resort Hotel | 1 | 45 | 2018 | July | 27 | 2 | 2 | 3 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 241 | 0 | Transient | 117.81 | 0 | 0 | Canceled |
| 9 | Resort Hotel | 1 | 47 | 2018 | July | 27 | 2 | 2 | 5 | 2 | 2 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 240 | 0 | Transient | 153.00 | 0 | 0 | Canceled |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | booking_changes | deposit_type | agent | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141487 | City Hotel | 1 | 219 | 2020 | August | 35 | 28 | 1 | 3 | 2 | 1 | 0 | BB | ROU | Online TA | TA/TO | 0 | 0 | 0 | 1 | No Deposit | 9 | 0 | Transient | 135.00 | 0 | 2 | No-Show |
| 141488 | City Hotel | 1 | 320 | 2020 | August | 35 | 28 | 2 | 5 | 2 | 0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | 0 | No Deposit | 9 | 0 | Transient | 112.76 | 0 | 3 | No-Show |
| 141489 | City Hotel | 1 | 1 | 2020 | March | 10 | 7 | 0 | 2 | 2 | 0 | 0 | SC | PRT | Direct | Direct | 1 | 0 | 1 | 0 | No Deposit | No Agent | 0 | Transient | 98.00 | 0 | 0 | No-Show |
| 141490 | City Hotel | 1 | 4 | 2020 | August | 35 | 28 | 1 | 0 | 1 | 0 | 0 | BB | PRT | Complementary | Corporate | 1 | 0 | 3 | 0 | No Deposit | No Agent | 0 | Transient | 0.00 | 0 | 2 | No-Show |
| 141491 | City Hotel | 1 | 2 | 2020 | June | 24 | 11 | 2 | 1 | 1 | 0 | 0 | BB | PRT | Aviation | Corporate | 1 | 0 | 2 | 0 | No Deposit | No Agent | 0 | Transient | 95.00 | 0 | 0 | No-Show |
| 141492 | City Hotel | 1 | 1 | 2020 | February | 5 | 1 | 0 | 0 | 1 | 0 | 0 | BB | AUT | Aviation | Corporate | 1 | 0 | 1 | 0 | No Deposit | No Agent | 0 | Transient | 0.00 | 0 | 1 | No-Show |
| 141493 | City Hotel | 1 | 31 | 2020 | July | 29 | 16 | 2 | 0 | 1 | 0 | 0 | BB | USA | Direct | Direct | 1 | 0 | 2 | 1 | No Deposit | No Agent | 0 | Transient | 135.00 | 0 | 2 | No-Show |
| 141494 | City Hotel | 1 | 25 | 2020 | May | 18 | 6 | 2 | 1 | 1 | 0 | 0 | BB | FRA | Corporate | Corporate | 1 | 0 | 1 | 0 | No Deposit | No Agent | 0 | Transient | 125.00 | 0 | 0 | No-Show |
| 141495 | City Hotel | 1 | 6 | 2020 | July | 29 | 17 | 1 | 0 | 1 | 0 | 0 | BB | PRT | Corporate | Corporate | 1 | 1 | 1 | 0 | No Deposit | No Agent | 0 | Transient | 65.00 | 0 | 0 | No-Show |
| 141496 | City Hotel | 1 | 0 | 2020 | August | 31 | 2 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Corporate | Corporate | 1 | 0 | 0 | 0 | No Deposit | No Agent | 0 | Transient | 65.00 | 0 | 1 | No-Show |
Most frequently occurring
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | booking_changes | deposit_type | agent | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6578 | City Hotel | 1 | 277 | 2019 | November | 46 | 7 | 1 | 2 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | 0 | Non Refund | No Agent | 0 | Transient | 100.0 | 0 | 0 | Canceled | 180 |
| 5193 | City Hotel | 1 | 68 | 2019 | February | 8 | 17 | 0 | 2 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | 0 | Non Refund | 37 | 0 | Transient | 75.0 | 0 | 0 | Canceled | 150 |
| 4799 | City Hotel | 1 | 34 | 2018 | December | 50 | 8 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | 0 | Non Refund | 19 | 0 | Transient | 90.0 | 0 | 0 | Canceled | 140 |
| 4803 | City Hotel | 1 | 34 | 2019 | December | 50 | 8 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | 0 | Non Refund | 19 | 0 | Transient | 90.0 | 0 | 0 | Canceled | 140 |
| 6200 | City Hotel | 1 | 188 | 2019 | June | 25 | 15 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | 0 | Non Refund | 119 | 39 | Transient | 130.0 | 0 | 0 | Canceled | 109 |
| 5996 | City Hotel | 1 | 158 | 2019 | May | 22 | 24 | 0 | 2 | 1 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | 0 | Non Refund | 37 | 31 | Transient | 130.0 | 0 | 0 | Canceled | 101 |
| 4730 | City Hotel | 1 | 28 | 2020 | March | 9 | 2 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | 0 | Non Refund | No Agent | 0 | Transient | 95.0 | 0 | 0 | Canceled | 99 |
| 4868 | City Hotel | 1 | 38 | 2020 | January | 2 | 14 | 0 | 1 | 1 | 0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | 0 | Non Refund | No Agent | 0 | Transient | 75.0 | 0 | 0 | Canceled | 99 |
| 5989 | City Hotel | 1 | 156 | 2020 | April | 17 | 26 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | 0 | Non Refund | 37 | 0 | Transient | 100.0 | 0 | 0 | Canceled | 99 |
| 5223 | City Hotel | 1 | 71 | 2019 | June | 25 | 14 | 0 | 3 | 1 | 0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | 0 | Non Refund | 236 | 0 | Transient | 120.0 | 0 | 0 | Canceled | 89 |